package com.zw.pm.gen.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TaskExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TaskExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeIsNull() {
            addCriterion("plan_complete_time is null");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeIsNotNull() {
            addCriterion("plan_complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeEqualTo(Date value) {
            addCriterion("plan_complete_time =", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeNotEqualTo(Date value) {
            addCriterion("plan_complete_time <>", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeGreaterThan(Date value) {
            addCriterion("plan_complete_time >", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("plan_complete_time >=", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeLessThan(Date value) {
            addCriterion("plan_complete_time <", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("plan_complete_time <=", value, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeIn(List<Date> values) {
            addCriterion("plan_complete_time in", values, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeNotIn(List<Date> values) {
            addCriterion("plan_complete_time not in", values, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("plan_complete_time between", value1, value2, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andPlanCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("plan_complete_time not between", value1, value2, "planCompleteTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(Integer value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(Integer value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(Integer value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(Integer value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(Integer value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<Integer> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<Integer> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(Integer value1, Integer value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(Integer value1, Integer value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNull() {
            addCriterion("project_id is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("project_id is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(Integer value) {
            addCriterion("project_id =", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualTo(Integer value) {
            addCriterion("project_id <>", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThan(Integer value) {
            addCriterion("project_id >", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("project_id >=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThan(Integer value) {
            addCriterion("project_id <", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualTo(Integer value) {
            addCriterion("project_id <=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIn(List<Integer> values) {
            addCriterion("project_id in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<Integer> values) {
            addCriterion("project_id not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(Integer value1, Integer value2) {
            addCriterion("project_id between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(Integer value1, Integer value2) {
            addCriterion("project_id not between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdIsNull() {
            addCriterion("factory_id is null");
            return (Criteria) this;
        }

        public Criteria andFactoryIdIsNotNull() {
            addCriterion("factory_id is not null");
            return (Criteria) this;
        }

        public Criteria andFactoryIdEqualTo(Integer value) {
            addCriterion("factory_id =", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdNotEqualTo(Integer value) {
            addCriterion("factory_id <>", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdGreaterThan(Integer value) {
            addCriterion("factory_id >", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("factory_id >=", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdLessThan(Integer value) {
            addCriterion("factory_id <", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("factory_id <=", value, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdIn(List<Integer> values) {
            addCriterion("factory_id in", values, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdNotIn(List<Integer> values) {
            addCriterion("factory_id not in", values, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdBetween(Integer value1, Integer value2) {
            addCriterion("factory_id between", value1, value2, "factoryId");
            return (Criteria) this;
        }

        public Criteria andFactoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("factory_id not between", value1, value2, "factoryId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdIsNull() {
            addCriterion("task_temp_id is null");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdIsNotNull() {
            addCriterion("task_temp_id is not null");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdEqualTo(Integer value) {
            addCriterion("task_temp_id =", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdNotEqualTo(Integer value) {
            addCriterion("task_temp_id <>", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdGreaterThan(Integer value) {
            addCriterion("task_temp_id >", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("task_temp_id >=", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdLessThan(Integer value) {
            addCriterion("task_temp_id <", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdLessThanOrEqualTo(Integer value) {
            addCriterion("task_temp_id <=", value, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdIn(List<Integer> values) {
            addCriterion("task_temp_id in", values, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdNotIn(List<Integer> values) {
            addCriterion("task_temp_id not in", values, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdBetween(Integer value1, Integer value2) {
            addCriterion("task_temp_id between", value1, value2, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andTaskTempIdNotBetween(Integer value1, Integer value2) {
            addCriterion("task_temp_id not between", value1, value2, "taskTempId");
            return (Criteria) this;
        }

        public Criteria andAliasIsNull() {
            addCriterion("alias is null");
            return (Criteria) this;
        }

        public Criteria andAliasIsNotNull() {
            addCriterion("alias is not null");
            return (Criteria) this;
        }

        public Criteria andAliasEqualTo(String value) {
            addCriterion("alias =", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotEqualTo(String value) {
            addCriterion("alias <>", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThan(String value) {
            addCriterion("alias >", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThanOrEqualTo(String value) {
            addCriterion("alias >=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThan(String value) {
            addCriterion("alias <", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThanOrEqualTo(String value) {
            addCriterion("alias <=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLike(String value) {
            addCriterion("alias like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotLike(String value) {
            addCriterion("alias not like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasIn(List<String> values) {
            addCriterion("alias in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotIn(List<String> values) {
            addCriterion("alias not in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasBetween(String value1, String value2) {
            addCriterion("alias between", value1, value2, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotBetween(String value1, String value2) {
            addCriterion("alias not between", value1, value2, "alias");
            return (Criteria) this;
        }

        public Criteria andNumIsNull() {
            addCriterion("num is null");
            return (Criteria) this;
        }

        public Criteria andNumIsNotNull() {
            addCriterion("num is not null");
            return (Criteria) this;
        }

        public Criteria andNumEqualTo(Integer value) {
            addCriterion("num =", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotEqualTo(Integer value) {
            addCriterion("num <>", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThan(Integer value) {
            addCriterion("num >", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("num >=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThan(Integer value) {
            addCriterion("num <", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThanOrEqualTo(Integer value) {
            addCriterion("num <=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumIn(List<Integer> values) {
            addCriterion("num in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotIn(List<Integer> values) {
            addCriterion("num not in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumBetween(Integer value1, Integer value2) {
            addCriterion("num between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotBetween(Integer value1, Integer value2) {
            addCriterion("num not between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andSprayNumIsNull() {
            addCriterion("spray_num is null");
            return (Criteria) this;
        }

        public Criteria andSprayNumIsNotNull() {
            addCriterion("spray_num is not null");
            return (Criteria) this;
        }

        public Criteria andSprayNumEqualTo(Integer value) {
            addCriterion("spray_num =", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumNotEqualTo(Integer value) {
            addCriterion("spray_num <>", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumGreaterThan(Integer value) {
            addCriterion("spray_num >", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("spray_num >=", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumLessThan(Integer value) {
            addCriterion("spray_num <", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumLessThanOrEqualTo(Integer value) {
            addCriterion("spray_num <=", value, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumIn(List<Integer> values) {
            addCriterion("spray_num in", values, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumNotIn(List<Integer> values) {
            addCriterion("spray_num not in", values, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumBetween(Integer value1, Integer value2) {
            addCriterion("spray_num between", value1, value2, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andSprayNumNotBetween(Integer value1, Integer value2) {
            addCriterion("spray_num not between", value1, value2, "sprayNum");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeIsNull() {
            addCriterion("first_ship_time is null");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeIsNotNull() {
            addCriterion("first_ship_time is not null");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeEqualTo(Date value) {
            addCriterion("first_ship_time =", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeNotEqualTo(Date value) {
            addCriterion("first_ship_time <>", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeGreaterThan(Date value) {
            addCriterion("first_ship_time >", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("first_ship_time >=", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeLessThan(Date value) {
            addCriterion("first_ship_time <", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeLessThanOrEqualTo(Date value) {
            addCriterion("first_ship_time <=", value, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeIn(List<Date> values) {
            addCriterion("first_ship_time in", values, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeNotIn(List<Date> values) {
            addCriterion("first_ship_time not in", values, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeBetween(Date value1, Date value2) {
            addCriterion("first_ship_time between", value1, value2, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andFirstShipTimeNotBetween(Date value1, Date value2) {
            addCriterion("first_ship_time not between", value1, value2, "firstShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeIsNull() {
            addCriterion("last_ship_time is null");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeIsNotNull() {
            addCriterion("last_ship_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeEqualTo(Date value) {
            addCriterion("last_ship_time =", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeNotEqualTo(Date value) {
            addCriterion("last_ship_time <>", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeGreaterThan(Date value) {
            addCriterion("last_ship_time >", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_ship_time >=", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeLessThan(Date value) {
            addCriterion("last_ship_time <", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_ship_time <=", value, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeIn(List<Date> values) {
            addCriterion("last_ship_time in", values, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeNotIn(List<Date> values) {
            addCriterion("last_ship_time not in", values, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeBetween(Date value1, Date value2) {
            addCriterion("last_ship_time between", value1, value2, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andLastShipTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_ship_time not between", value1, value2, "lastShipTime");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(Double value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(Double value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(Double value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(Double value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(Double value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<Double> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<Double> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(Double value1, Double value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(Double value1, Double value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andReasonIsNull() {
            addCriterion("reason is null");
            return (Criteria) this;
        }

        public Criteria andReasonIsNotNull() {
            addCriterion("reason is not null");
            return (Criteria) this;
        }

        public Criteria andReasonEqualTo(String value) {
            addCriterion("reason =", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotEqualTo(String value) {
            addCriterion("reason <>", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThan(String value) {
            addCriterion("reason >", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanOrEqualTo(String value) {
            addCriterion("reason >=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThan(String value) {
            addCriterion("reason <", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThanOrEqualTo(String value) {
            addCriterion("reason <=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLike(String value) {
            addCriterion("reason like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotLike(String value) {
            addCriterion("reason not like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonIn(List<String> values) {
            addCriterion("reason in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotIn(List<String> values) {
            addCriterion("reason not in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonBetween(String value1, String value2) {
            addCriterion("reason between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotBetween(String value1, String value2) {
            addCriterion("reason not between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeIsNull() {
            addCriterion("main_complete_time is null");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeIsNotNull() {
            addCriterion("main_complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeEqualTo(Date value) {
            addCriterion("main_complete_time =", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeNotEqualTo(Date value) {
            addCriterion("main_complete_time <>", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeGreaterThan(Date value) {
            addCriterion("main_complete_time >", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("main_complete_time >=", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeLessThan(Date value) {
            addCriterion("main_complete_time <", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("main_complete_time <=", value, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeIn(List<Date> values) {
            addCriterion("main_complete_time in", values, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeNotIn(List<Date> values) {
            addCriterion("main_complete_time not in", values, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("main_complete_time between", value1, value2, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andMainCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("main_complete_time not between", value1, value2, "mainCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeIsNull() {
            addCriterion("iron_complete_time is null");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeIsNotNull() {
            addCriterion("iron_complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeEqualTo(Date value) {
            addCriterion("iron_complete_time =", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeNotEqualTo(Date value) {
            addCriterion("iron_complete_time <>", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeGreaterThan(Date value) {
            addCriterion("iron_complete_time >", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("iron_complete_time >=", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeLessThan(Date value) {
            addCriterion("iron_complete_time <", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("iron_complete_time <=", value, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeIn(List<Date> values) {
            addCriterion("iron_complete_time in", values, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeNotIn(List<Date> values) {
            addCriterion("iron_complete_time not in", values, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("iron_complete_time between", value1, value2, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andIronCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("iron_complete_time not between", value1, value2, "ironCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeIsNull() {
            addCriterion("back_complete_time is null");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeIsNotNull() {
            addCriterion("back_complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeEqualTo(Date value) {
            addCriterion("back_complete_time =", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeNotEqualTo(Date value) {
            addCriterion("back_complete_time <>", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeGreaterThan(Date value) {
            addCriterion("back_complete_time >", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("back_complete_time >=", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeLessThan(Date value) {
            addCriterion("back_complete_time <", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("back_complete_time <=", value, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeIn(List<Date> values) {
            addCriterion("back_complete_time in", values, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeNotIn(List<Date> values) {
            addCriterion("back_complete_time not in", values, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("back_complete_time between", value1, value2, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andBackCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("back_complete_time not between", value1, value2, "backCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeIsNull() {
            addCriterion("support_complete_time is null");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeIsNotNull() {
            addCriterion("support_complete_time is not null");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeEqualTo(Date value) {
            addCriterion("support_complete_time =", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeNotEqualTo(Date value) {
            addCriterion("support_complete_time <>", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeGreaterThan(Date value) {
            addCriterion("support_complete_time >", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("support_complete_time >=", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeLessThan(Date value) {
            addCriterion("support_complete_time <", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeLessThanOrEqualTo(Date value) {
            addCriterion("support_complete_time <=", value, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeIn(List<Date> values) {
            addCriterion("support_complete_time in", values, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeNotIn(List<Date> values) {
            addCriterion("support_complete_time not in", values, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeBetween(Date value1, Date value2) {
            addCriterion("support_complete_time between", value1, value2, "supportCompleteTime");
            return (Criteria) this;
        }

        public Criteria andSupportCompleteTimeNotBetween(Date value1, Date value2) {
            addCriterion("support_complete_time not between", value1, value2, "supportCompleteTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}